﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css">
h1
{
    color:black;
    text-align:left;
}
p
{
    font-family: "Verdana";
    font-size:20px;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Modelo Canônico - Loja Virtual Livraria</title>
</head>

<body>
<table width="800" border="0">
  <tr>
    <td width="790"><h1>Modelo Canônico - Loja Virtual Livraria</h1></td>
  </tr>
  <tr>
    <td><em>Alunos: Arthur Mourão, Thyago Deluca, Raphael Cruz Alves, Rodrigo Caldas.</em></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<table width="1315" border="1">
  <tr>
    <td width="140">&nbsp;</td>
    <td width="140"><strong>Pessoa</strong></td>
    <td width="140"><strong>Fisica</strong></td>
    <td width="140"><strong>Juridica</strong></td>
    <td width="140"><strong>Telefone</strong></td>
    <td width="140"><strong>Venda</strong></td>
    <td width="140"><strong>ItemVenda</strong></td>
    <td width="140"><strong>Produto</strong></td>
    <td width="137"><strong>Endereco</strong></td>
  </tr>
  <tr>
    <td><strong>pessoaID</strong></td>
    <td>unsigned int</td>
    <td>unsigned int</td>
    <td>unsigned int</td>
    <td>unsigned int</td>
    <td>unsigned int</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
  </tr>
  <tr>
    <td><strong>email</strong></td>
    <td>string (5,80)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>observacao</strong></td>
    <td>string (0,500)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>login</strong></td>
    <td>string (5,15)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>senha</strong></td>
    <td>string (8,10)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>fisicaID</strong></td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>nome</strong></td>
    <td>&nbsp;</td>
    <td>string (3,100)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>cpf</strong></td>
    <td>&nbsp;</td>
    <td>string (11)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>rg</strong></td>
    <td>&nbsp;</td>
    <td>string (5,20)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>dataNascimento</strong></td>
    <td>&nbsp;</td>
    <td>date dd-mm-yy</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>juridicaID</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>razaoSocial</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (5,100)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>cnpj</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (6,12)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>inscEstadual</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (6,10)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>inscMunicipal</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (6,10)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>dataFundacao</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>date dd-mm-yy</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>telefoneID</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>numero</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (6-20)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>ddd</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (2,3)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>tipoTelefone</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>enum tipoTelefone</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>vendaID</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>dataVenda</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>date dd-mm-yy</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>itemVendaID</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>quantidade</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>produtoID</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
    <td>unsigned int</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>nome (produto)</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (3-40)</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>descricao</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (10-350)</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>valor</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>double</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><strong>enderecoID</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>unsigned int</td>
  </tr>
  <tr>
    <td><strong>logradouro</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (5,80)</td>
  </tr>
  <tr>
    <td><strong>uf</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>char (2)</td>
  </tr>
  <tr>
    <td><strong>cidade</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (5,15)</td>
  </tr>
  <tr>
    <td><strong>bairro</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (5,20)</td>
  </tr>
  <tr>
    <td><strong>complemento</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>string (null,30)</td>
  </tr>
  <tr>
    <td><strong>tipoEndereco</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>enum tipoEndereco</td>
  </tr>
</table>
</body>
</html>
